SaBankAccount

Logical Entity Name | SaBankAccount
Default Table Name | SaBankAccount
Physical Only | NO
Owner | dbo
Definition |
Note |

SaBankAccount Columns

ColumnName | Domain | Datatype | NULL | Definition
SaBankAccountID |  | int | NO |
SaBankID |  | int | NO |
AccountNo |  | varchar(17) | NO |
Descrip |  | varchar(35) | NO |
DefaultAccount |  | bit | NO |
GLDebitAccount |  | nvarchar(100) | YES |
GLCreditAccount |  | nvarchar(100) | YES |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
UserID |  | int | NO |
Active |  | bit | NO |
ts |  | timestamp | NO |
CAcctIndex |  | int | YES |
DAcctIndex |  | int | YES |
FractionalNumber |  | char(15) | YES |
PaymentType |  | char(1) | NO |
GPCheckBook |  | char(15) | YES |
GPNextCheckFlag |  | bit | NO |
DefaultCash |  | bit | NO |
DefaultCheck |  | bit | NO |
DefaultEFT |  | bit | NO |
DefaultACH |  | bit | NO |
DefaultNonCash |  | bit | NO |
DefaultCreditCard |  | bit | NO |
DefaultAllTypes |  | bit | NO |
NSFPendingAccount |  | nvarchar(100) | YES |
DepositsPendingAccount |  | nvarchar(100) | YES |
Currency |  | varchar(25) | YES |
DepositIdentifierFormat |  | varchar(40) | YES |
DirectDepositOriginNumber |  | varchar(10) | YES |
LastDirectDepositNumber |  | int | YES |
LastCheckNumber |  | int | YES |
PositivePayExclude |  | bit | NO |

SaBankAccount Primary and Unique Keys

Key Name | Key Type | Keys
SaBankAccount_SaBankAccountID_U_C_IDX | PrimaryKey | SaBankAccountID

SaBankAccount Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
SaBankAccountFS | Non-Identifying | One To Zero or More | FK_FaFundSourceID_SaBankAccountID_SaBankAccount_SaBankAccountID |  |  |  | NO | YES
SaACHConfigCampus | Non-Identifying | One To Zero or More | FK_SaACHConfigCampus_SaBankAccountID_SaBankAccount_SaBankAccountID |  |  |  | NO | YES
SaReconcileDeposit | Non-Identifying | One To Zero or More | FK_SaReconcileDepositSaBankAccountId_SaBankAccountSaBankAccountId |  |  |  | NO | YES
SaReconcileReturnFund | Non-Identifying | One To Zero or More | FK_SaReconcileReturnFundSaBankAccountID_SaBankAccountSaBankAccountID |  |  |  | NO | YES
SaReconcileTransferFunds | Non-Identifying | One To Zero or More | FK_SaReconcileTransferFundsFromSaBankAccountID_SaBankAccountSaBankAccountID |  |  |  | NO | YES
SaReconcileTransferFunds | Non-Identifying | One To Zero or More | FK_SaReconcileTransferFundsToSaBankAccountID_SaBankAccountSaBankAccountID |  |  |  | NO | YES
SaStudSubsidiaryTrans | Non-Identifying | One To Zero or More | Fk_SaStudSubsidiaryTrans_SaBankAccountID_SaBankAccount_SaBankAccountID |  |  |  | NO | YES
SaSubsidiaryRefund | Non-Identifying | One To Zero or More | Fk_SaSubsidiaryRefund_SaBankAccountID_SaBAnkAccount_SaBankAccountID |  |  |  | NO | YES
SaTransPendingChecks | Non-Identifying | Zero or One to Zero or More | FK_SaTransPendingChecks_SaBankAccountId_SaBankAccount_SaBankAccountId |  |  |  | NO | YES

SaBankAccount Check Constraints

Check Constraint Name | CheckConstraint

SaBankAccount Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SaBankAccount Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.BankAccount | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaBankAccount | NO |  |  |

SaBankAccount Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ElectronicPaymentProcessing
Logical | Revenue_GL_BankDeposit
Logical | SubsidiaryLedger
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

SaBankAccount Data Movement Rules

Name | Type | Rule Text/Value